/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.0.251
 Source Server Type    : PostgreSQL
 Source Server Version : 100004
 Source Host           : 192.168.0.251:15432
 Source Catalog        : db_oauth
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 100004
 File Encoding         : 65001

 Date: 26/09/2018 15:16:50
*/


-- ----------------------------
-- Sequence structure for ApiClaims_Id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "ApiClaims_Id_seq";
CREATE SEQUENCE "ApiClaims_Id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;

-- ----------------------------
-- Table structure for t_account
-- ----------------------------
DROP TABLE IF EXISTS "t_account";
CREATE TABLE "t_account" (
  "Id" uuid NOT NULL,
  "Account" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "Mobile" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "Password" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,
  "PasswordSalt" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,
  "Email" varchar(128) COLLATE "pg_catalog"."default",
  "Type" int4 NOT NULL,
  "State" int2 NOT NULL,
  "CreateTime" timestamp(0) NOT NULL,
  "LastLoginTime" timestamp(0),
  "EncryptionType" int2 NOT NULL,
  "AuthTypes" int4 NOT NULL
)
;
COMMENT ON COLUMN "t_account"."Account" IS '帐号';
COMMENT ON COLUMN "t_account"."Mobile" IS '手机号';
COMMENT ON COLUMN "t_account"."Password" IS '密码';
COMMENT ON COLUMN "t_account"."PasswordSalt" IS '密码盐';
COMMENT ON COLUMN "t_account"."Email" IS '邮箱';
COMMENT ON COLUMN "t_account"."Type" IS '类型';
COMMENT ON COLUMN "t_account"."State" IS '状态';
COMMENT ON COLUMN "t_account"."LastLoginTime" IS '最后登录时间';
COMMENT ON COLUMN "t_account"."EncryptionType" IS '加密类型:0,MD5';
COMMENT ON COLUMN "t_account"."AuthTypes" IS '认证类型:1,手机号;2,邮箱';

-- ----------------------------
-- Records of t_account
-- ----------------------------
BEGIN;
INSERT INTO "t_account" VALUES ('a1128d7b-1d8d-c965-ef23-08d623b6cccd', 'shay', '18214545789', '52130C9CD0A5569AD16DC27796705244', 'c7a1308273080844', 'AliceSmith@email.com', 0, 0, '2018-09-26 13:48:55', NULL, 0, 0);
INSERT INTO "t_account" VALUES ('b4e0975d-537f-ccf4-e261-08d623b6cccf', 'shay001', '18213268549', '053DCADA4BE367AD42CE9847FA9D97C8', '67a156d4a9ac9d44', 'BobSmith@email.com', 0, 0, '2018-09-26 13:48:55', NULL, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_account_login
-- ----------------------------
DROP TABLE IF EXISTS "t_account_login";
CREATE TABLE "t_account_login" (
  "Id" uuid NOT NULL,
  "AccountId" uuid NOT NULL,
  "AccountType" int4 NOT NULL,
  "PlatformType" int2 NOT NULL,
  "State" int2 NOT NULL,
  "Remark" varchar(255) COLLATE "pg_catalog"."default",
  "UserAgent" varchar(1024) COLLATE "pg_catalog"."default" NOT NULL,
  "ClientIp" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,
  "CreateTime" timestamp(0) NOT NULL
)
;

-- ----------------------------
-- Table structure for t_account_platform
-- ----------------------------
DROP TABLE IF EXISTS "t_account_platform";
CREATE TABLE "t_account_platform" (
  "Id" uuid NOT NULL,
  "AccountId" uuid NOT NULL,
  "Type" int2 NOT NULL,
  "OpenId" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,
  "UnionId" varchar(128) COLLATE "pg_catalog"."default",
  "Nick" varchar(128) COLLATE "pg_catalog"."default",
  "Avatar" varchar(1024) COLLATE "pg_catalog"."default",
  "AccessToken" varchar(1024) COLLATE "pg_catalog"."default",
  "RefreshToken" varchar(1024) COLLATE "pg_catalog"."default",
  "LoginTime" timestamp(0),
  "CreateTime" timestamp(0) NOT NULL,
  "ExpiredTime" timestamp(0),
  "State" int2 NOT NULL
)
;
COMMENT ON COLUMN "t_account_platform"."Type" IS '平台类型';
COMMENT ON COLUMN "t_account_platform"."UnionId" IS '平台唯一ID';
COMMENT ON COLUMN "t_account_platform"."Nick" IS '昵称';
COMMENT ON COLUMN "t_account_platform"."Avatar" IS '头像';
COMMENT ON COLUMN "t_account_platform"."LoginTime" IS '登录时间';
COMMENT ON COLUMN "t_account_platform"."CreateTime" IS '创建时间';
COMMENT ON COLUMN "t_account_platform"."ExpiredTime" IS '过期时间';
COMMENT ON COLUMN "t_account_platform"."State" IS '状态';

-- ----------------------------
-- Table structure for t_client
-- ----------------------------
DROP TABLE IF EXISTS "t_client";
CREATE TABLE "t_client" (
  "Id" uuid NOT NULL,
  "Enabled" bool NOT NULL,
  "ClientId" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "ProtocolType" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "RequireClientSecret" bool NOT NULL,
  "ClientName" varchar(200) COLLATE "pg_catalog"."default",
  "Description" varchar(1000) COLLATE "pg_catalog"."default",
  "ClientUri" varchar(2000) COLLATE "pg_catalog"."default",
  "LogoUri" varchar(2000) COLLATE "pg_catalog"."default",
  "RequireConsent" bool NOT NULL,
  "AllowRememberConsent" bool NOT NULL,
  "AlwaysIncludeUserClaimsInIdToken" bool NOT NULL,
  "RequirePkce" bool NOT NULL,
  "AllowPlainTextPkce" bool NOT NULL,
  "AllowAccessTokensViaBrowser" bool NOT NULL,
  "FrontChannelLogoutUri" varchar(2000) COLLATE "pg_catalog"."default",
  "FrontChannelLogoutSessionRequired" bool NOT NULL,
  "BackChannelLogoutUri" varchar(2000) COLLATE "pg_catalog"."default",
  "BackChannelLogoutSessionRequired" bool NOT NULL,
  "AllowOfflineAccess" bool NOT NULL,
  "IdentityTokenLifetime" int4 NOT NULL,
  "AccessTokenLifetime" int4 NOT NULL,
  "AuthorizationCodeLifetime" int4 NOT NULL,
  "ConsentLifetime" int4,
  "AbsoluteRefreshTokenLifetime" int4 NOT NULL,
  "SlidingRefreshTokenLifetime" int4 NOT NULL,
  "RefreshTokenUsage" int4 NOT NULL,
  "UpdateAccessTokenClaimsOnRefresh" bool NOT NULL,
  "RefreshTokenExpiration" int4 NOT NULL,
  "AccessTokenType" int4 NOT NULL,
  "EnableLocalLogin" bool NOT NULL,
  "IncludeJwtId" bool NOT NULL,
  "AlwaysSendClientClaims" bool NOT NULL,
  "ClientClaimsPrefix" varchar(200) COLLATE "pg_catalog"."default",
  "PairWiseSubjectSalt" varchar(200) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of t_client
-- ----------------------------
BEGIN;
INSERT INTO "t_client" VALUES ('50d825bc-fd6e-cb19-d6d3-08d623b6cc7c', 't', 'shay', 'oidc', 't', NULL, NULL, NULL, NULL, 't', 't', 'f', 'f', 'f', 'f', NULL, 't', NULL, 't', 't', 300, 7200, 300, 0, 1800, 1296000, 1, 't', 1, 0, 't', 'f', 'f', 'client_', NULL);
INSERT INTO "t_client" VALUES ('4425e979-76e6-ca80-4b83-08d623b6ccc2', 't', 'shay_code', 'oidc', 't', 'i车保应用', NULL, NULL, 'http://oss.i-cbao.com/icb.png', 't', 't', 'f', 'f', 'f', 't', NULL, 't', NULL, 't', 't', 300, 7200, 300, 0, 2592000, 1296000, 1, 'f', 1, 0, 't', 'f', 'f', 'client_', NULL);
INSERT INTO "t_client" VALUES ('d9c45bc6-b72e-c2ca-c279-08d623b6ccc6', 't', 'implicit', 'oidc', 't', NULL, NULL, NULL, NULL, 't', 't', 'f', 'f', 'f', 't', NULL, 't', NULL, 't', 'f', 300, 7200, 300, 0, 2592000, 1296000, 1, 'f', 1, 0, 't', 'f', 'f', 'client_', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_client_claim
-- ----------------------------
DROP TABLE IF EXISTS "t_client_claim";
CREATE TABLE "t_client_claim" (
  "Id" uuid NOT NULL,
  "Type" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "Value" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "ClientId" uuid NOT NULL
)
;

-- ----------------------------
-- Table structure for t_client_config
-- ----------------------------
DROP TABLE IF EXISTS "t_client_config";
CREATE TABLE "t_client_config" (
  "Id" uuid NOT NULL,
  "Scopes" json,
  "Origins" json,
  "Grants" json,
  "Providers" json,
  "Uris" json,
  "LogoutUris" json
)
;
COMMENT ON COLUMN "t_client_config"."Scopes" IS '领域列表';
COMMENT ON COLUMN "t_client_config"."Origins" IS '跨域列表';
COMMENT ON COLUMN "t_client_config"."Grants" IS '认证方式列表';
COMMENT ON COLUMN "t_client_config"."Providers" IS '限制的提供者列表';
COMMENT ON COLUMN "t_client_config"."Uris" IS '重定向URL列表';
COMMENT ON COLUMN "t_client_config"."LogoutUris" IS '退出登录重定向列表';

-- ----------------------------
-- Records of t_client_config
-- ----------------------------
BEGIN;
INSERT INTO "t_client_config" VALUES ('50d825bc-fd6e-cb19-d6d3-08d623b6cc7c', '["shay_api","offline_access","openid","profile"]', NULL, '["password","client_credentials"]', NULL, '["http://www.baidu.com"]', NULL);
INSERT INTO "t_client_config" VALUES ('4425e979-76e6-ca80-4b83-08d623b6ccc2', '["shay_api","openid","profile"]', NULL, '["authorization_code"]', NULL, '["http://www.baidu.com"]', NULL);
INSERT INTO "t_client_config" VALUES ('d9c45bc6-b72e-c2ca-c279-08d623b6ccc6', '["shay_api","openid","profile"]', NULL, '["implicit"]', NULL, '["http://localhost:53690/signin-oidc"]', '["http://localhost:53690/signout-callback-oidc"]');
COMMIT;

-- ----------------------------
-- Table structure for t_client_property
-- ----------------------------
DROP TABLE IF EXISTS "t_client_property";
CREATE TABLE "t_client_property" (
  "Id" uuid NOT NULL,
  "Key" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "Value" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "ClientId" uuid NOT NULL
)
;

-- ----------------------------
-- Table structure for t_grant
-- ----------------------------
DROP TABLE IF EXISTS "t_grant";
CREATE TABLE "t_grant" (
  "Id" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "Type" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "SubjectId" varchar(200) COLLATE "pg_catalog"."default",
  "ClientId" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "Data" text COLLATE "pg_catalog"."default",
  "CreateTime" timestamp(0) NOT NULL,
  "ExpiredTime" timestamp(0)
)
;
COMMENT ON COLUMN "t_grant"."Type" IS '类型';
COMMENT ON COLUMN "t_grant"."ClientId" IS '客户端ID';
COMMENT ON COLUMN "t_grant"."Data" IS '数据';

-- ----------------------------
-- Records of t_grant
-- ----------------------------
BEGIN;
INSERT INTO "t_grant" VALUES ('U+ihVEpot/ZT2p7co02FcJk/biIqLllhFiEKc74u88U=', 'authorization_code', 'a1128d7b-1d8d-c965-ef23-08d623b6cccd', 'shay_code', '{"CreationTime":"2018-09-26T07:08:15Z","Lifetime":300,"ClientId":"shay_code","Subject":{"AuthenticationType":"IdentityServer4","Claims":[{"Type":"sub","Value":"a1128d7b-1d8d-c965-ef23-08d623b6cccd","ValueType":null},{"Type":"name","Value":"shay","ValueType":null},{"Type":"auth_time","Value":"1537944274","ValueType":null},{"Type":"phone_number","Value":"18214545789","ValueType":null},{"Type":"phone_number_verified","Value":"False","ValueType":null},{"Type":"email","Value":"AliceSmith@email.com","ValueType":null},{"Type":"email_verified","Value":"False","ValueType":null},{"Type":"idp","Value":"local","ValueType":null},{"Type":"amr","Value":"pwd","ValueType":null}]},"IsOpenId":false,"RequestedScopes":["shay_api"],"RedirectUri":"http://www.baidu.com","Nonce":null,"WasConsentShown":true,"SessionId":"fcba75e50c8545231b3b98f346cdc9c2","CodeChallenge":"","CodeChallengeMethod":null}', '2018-09-26 07:08:15', '2018-09-26 07:13:15');
INSERT INTO "t_grant" VALUES ('Azg3aqgsgL81VuM7CN4lVeOz/RqH4xHsnVKULSn0rLk=', 'authorization_code', 'a1128d7b-1d8d-c965-ef23-08d623b6cccd', 'shay_code', '{"CreationTime":"2018-09-26T07:10:24Z","Lifetime":300,"ClientId":"shay_code","Subject":{"AuthenticationType":"IdentityServer4","Claims":[{"Type":"sub","Value":"a1128d7b-1d8d-c965-ef23-08d623b6cccd","ValueType":null},{"Type":"name","Value":"shay","ValueType":null},{"Type":"auth_time","Value":"1537944274","ValueType":null},{"Type":"phone_number","Value":"18214545789","ValueType":null},{"Type":"phone_number_verified","Value":"False","ValueType":null},{"Type":"email","Value":"AliceSmith@email.com","ValueType":null},{"Type":"email_verified","Value":"False","ValueType":null},{"Type":"idp","Value":"local","ValueType":null},{"Type":"amr","Value":"pwd","ValueType":null}]},"IsOpenId":false,"RequestedScopes":["shay_api"],"RedirectUri":"http://www.baidu.com","Nonce":null,"WasConsentShown":true,"SessionId":"fcba75e50c8545231b3b98f346cdc9c2","CodeChallenge":"","CodeChallengeMethod":null}', '2018-09-26 07:10:24', '2018-09-26 07:15:24');
INSERT INTO "t_grant" VALUES ('/9lVDpdSjGZe3VQJsP1CGCuuSiwAfzn024oK0rmIG+w=', 'authorization_code', 'a1128d7b-1d8d-c965-ef23-08d623b6cccd', 'shay_code', '{"CreationTime":"2018-09-26T07:10:39Z","Lifetime":300,"ClientId":"shay_code","Subject":{"AuthenticationType":"IdentityServer4","Claims":[{"Type":"sub","Value":"a1128d7b-1d8d-c965-ef23-08d623b6cccd","ValueType":null},{"Type":"name","Value":"shay","ValueType":null},{"Type":"auth_time","Value":"1537944274","ValueType":null},{"Type":"phone_number","Value":"18214545789","ValueType":null},{"Type":"phone_number_verified","Value":"False","ValueType":null},{"Type":"email","Value":"AliceSmith@email.com","ValueType":null},{"Type":"email_verified","Value":"False","ValueType":null},{"Type":"idp","Value":"local","ValueType":null},{"Type":"amr","Value":"pwd","ValueType":null}]},"IsOpenId":false,"RequestedScopes":["shay_api"],"RedirectUri":"http://www.baidu.com","Nonce":null,"WasConsentShown":true,"SessionId":"fcba75e50c8545231b3b98f346cdc9c2","CodeChallenge":"","CodeChallengeMethod":null}', '2018-09-26 07:10:39', '2018-09-26 07:15:39');
INSERT INTO "t_grant" VALUES ('FVObXn9xX7QB+YRBqp1Lr46l8PNP8yA5z2V0DLWvZvA=', 'user_consent', 'a1128d7b-1d8d-c965-ef23-08d623b6cccd', 'shay_code', '{"SubjectId":"a1128d7b-1d8d-c965-ef23-08d623b6cccd","ClientId":"shay_code","Scopes":["shay_api"],"CreationTime":"2018-09-26T07:14:56Z","Expiration":"2018-09-26T07:14:56Z"}', '2018-09-26 07:14:56', '2018-09-26 07:14:56');
INSERT INTO "t_grant" VALUES ('wk4Xx2p9tbRhs83R095HTg9dQKh/Rv4yJfxXAkiuarM=', 'authorization_code', 'a1128d7b-1d8d-c965-ef23-08d623b6cccd', 'shay_code', '{"CreationTime":"2018-09-26T07:14:56Z","Lifetime":300,"ClientId":"shay_code","Subject":{"AuthenticationType":"IdentityServer4","Claims":[{"Type":"sub","Value":"a1128d7b-1d8d-c965-ef23-08d623b6cccd","ValueType":null},{"Type":"name","Value":"shay","ValueType":null},{"Type":"auth_time","Value":"1537944274","ValueType":null},{"Type":"phone_number","Value":"18214545789","ValueType":null},{"Type":"phone_number_verified","Value":"False","ValueType":null},{"Type":"email","Value":"AliceSmith@email.com","ValueType":null},{"Type":"email_verified","Value":"False","ValueType":null},{"Type":"idp","Value":"local","ValueType":null},{"Type":"amr","Value":"pwd","ValueType":null}]},"IsOpenId":false,"RequestedScopes":["shay_api"],"RedirectUri":"http://www.baidu.com","Nonce":null,"WasConsentShown":true,"SessionId":"fcba75e50c8545231b3b98f346cdc9c2","CodeChallenge":"","CodeChallengeMethod":null}', '2018-09-26 07:14:56', '2018-09-26 07:19:56');
COMMIT;

-- ----------------------------
-- Table structure for t_resource
-- ----------------------------
DROP TABLE IF EXISTS "t_resource";
CREATE TABLE "t_resource" (
  "Id" uuid NOT NULL,
  "Name" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,
  "Title" varchar(512) COLLATE "pg_catalog"."default" NOT NULL,
  "Description" text COLLATE "pg_catalog"."default",
  "Enabled" bool NOT NULL,
  "Required" bool NOT NULL,
  "Emphasize" bool NOT NULL,
  "ShowInDiscoveryDocument" bool NOT NULL,
  "Type" int2 NOT NULL,
  "Claims" json
)
;
COMMENT ON COLUMN "t_resource"."Name" IS '资源名称';
COMMENT ON COLUMN "t_resource"."Title" IS '资源标题';
COMMENT ON COLUMN "t_resource"."Description" IS '资源描述';
COMMENT ON COLUMN "t_resource"."Enabled" IS '是否启用';
COMMENT ON COLUMN "t_resource"."Required" IS '是否必须';
COMMENT ON COLUMN "t_resource"."Emphasize" IS '是否强调';
COMMENT ON COLUMN "t_resource"."ShowInDiscoveryDocument" IS '是否在文档中展示';
COMMENT ON COLUMN "t_resource"."Type" IS '资源类型：0,Identity;1,Api';
COMMENT ON COLUMN "t_resource"."Claims" IS '资源声明';

-- ----------------------------
-- Records of t_resource
-- ----------------------------
BEGIN;
INSERT INTO "t_resource" VALUES ('129f880c-c0f1-c3da-0b92-08d623b6ccc9', 'shay_api', '获取店铺信息', NULL, 't', 'f', 'f', 'f', 1, NULL);
INSERT INTO "t_resource" VALUES ('267e515d-fc63-c860-beee-08d623b6ccca', 'openid', '获得您的ID', NULL, 't', 't', 'f', 't', 0, '["sub"]');
INSERT INTO "t_resource" VALUES ('e68bb18d-dbe8-cf69-f5b7-08d623b6cccc', 'profile', '获得您的昵称、头像、性别', '', 't', 't', 'f', 't', 0, '["name","family_name","given_name","middle_name","nickname","preferred_username","profile","picture","website","gender","birthdate","zoneinfo","locale","updated_at"]');
COMMIT;

-- ----------------------------
-- Table structure for t_secret
-- ----------------------------
DROP TABLE IF EXISTS "t_secret";
CREATE TABLE "t_secret" (
  "Id" uuid NOT NULL,
  "Title" varchar(255) COLLATE "pg_catalog"."default",
  "Source" int2 NOT NULL,
  "SourceId" uuid NOT NULL,
  "Type" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "Data" varchar(2048) COLLATE "pg_catalog"."default" NOT NULL,
  "ExpiredTime" timestamp(6)
)
;

-- ----------------------------
-- Records of t_secret
-- ----------------------------
BEGIN;
INSERT INTO "t_secret" VALUES ('de26ea80-4557-cc9a-5612-08d623b6ccbb', NULL, 0, '50d825bc-fd6e-cb19-d6d3-08d623b6cc7c', 'SharedSecret', 'K7gNU3sdo+OL0wNhqoVWhr3g6s1xYv72ol/pe/Unols=', NULL);
INSERT INTO "t_secret" VALUES ('5207acce-9309-c1c5-6d4c-08d623b6ccc3', NULL, 0, '4425e979-76e6-ca80-4b83-08d623b6ccc2', 'SharedSecret', 'K7gNU3sdo+OL0wNhqoVWhr3g6s1xYv72ol/pe/Unols=', NULL);
COMMIT;

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
SELECT setval('"ApiClaims_Id_seq"', 2, false);

-- ----------------------------
-- Primary Key structure for table t_account_login
-- ----------------------------
ALTER TABLE "t_account_login" ADD CONSTRAINT "t_account_login_pkey" PRIMARY KEY ("Id");

-- ----------------------------
-- Primary Key structure for table t_account_platform
-- ----------------------------
ALTER TABLE "t_account_platform" ADD CONSTRAINT "t_account_platform_pkey" PRIMARY KEY ("Id");

-- ----------------------------
-- Indexes structure for table t_client
-- ----------------------------
CREATE UNIQUE INDEX "IX_Clients_ClientId" ON "t_client" USING btree (
  "ClientId" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table t_client
-- ----------------------------
ALTER TABLE "t_client" ADD CONSTRAINT "PK_Clients" PRIMARY KEY ("Id");

-- ----------------------------
-- Primary Key structure for table t_client_config
-- ----------------------------
ALTER TABLE "t_client_config" ADD CONSTRAINT "t_client_config_pkey" PRIMARY KEY ("Id");

-- ----------------------------
-- Primary Key structure for table t_client_property
-- ----------------------------
ALTER TABLE "t_client_property" ADD CONSTRAINT "t_client_property_pkey" PRIMARY KEY ("Id");

-- ----------------------------
-- Primary Key structure for table t_grant
-- ----------------------------
ALTER TABLE "t_grant" ADD CONSTRAINT "t_grant_pkey" PRIMARY KEY ("Id");

-- ----------------------------
-- Primary Key structure for table t_resource
-- ----------------------------
ALTER TABLE "t_resource" ADD CONSTRAINT "t_resource_pkey" PRIMARY KEY ("Id");

-- ----------------------------
-- Primary Key structure for table t_secret
-- ----------------------------
ALTER TABLE "t_secret" ADD CONSTRAINT "t_secret_pkey" PRIMARY KEY ("Id");
